Spreadsheet Homework 3

Create a spreadsheet that calculates simple and compound interest
at 6% on a deposit of $1000, for 20 years, and which automatically
recalculates if the 6% or the $1000 is changed.

Your spreadsheet should look something like this.  

Firstname Lastname (MUST BE TYPED!)
Spreadsheet Homework #3: Simple and Compound Interest

	Initial deposit:
	$1000	

Years 	Rate		Simple	Int.	Interest	Simple		|Compound	Interest
since	This		Main	Earned	Balance		Combined	|Balance	Earned
start  	Year		Balance	ThisYr	at start	Balance		|		This Year
					of year				|
0	6%		$1000	$60	 $0		$1000		|$1000.00	$60.00
1	6%		$1000	$60	 $60		$1060		|$1060.00	$63.60
2	6%		$1000	$60	 $120		$1120		|$1123.60	$??.??
etc--you must fill in these rows.
20	6%		$1000	$60	 $???		$????		|$????.??	$???.??

The question marks are numbers that you will have to determine.
You should not do the calculations by hand or copy from anywhere--
instead, type formulas in to the spreadsheet.  No numbers (like 0 or 60 or 120) should
appear in your formulas on or below year #1.

I will test your spreadsheet by:
* changing the 6% at the top of its column to another value, and making sure all the calculations work.
* Changing the initial deposit of $1000 to another value, and making sure all the calculations work.
So, you should test your spreadsheet that way too!

You do not need to graph the results.